create table am_cart(
        id mediumint unsigned not null auto_increment comment 'ID',
        goods_id mediumint unsigned not null comment '商品ID',
        goods_number mediumint unsigned not null comment '购买的数量',
        member_id mediumint unsigned not null comment '会员ID',
        price decimal(10,2) not null comment '购买价格',
        primary key (id),
        key member_id(member_id),
        key goods_id(goods_id)
)engine=InnoDB default charset=utf8 comment '购物车表';